package com.mapper;

import com.pojo.Worker;
import org.apache.ibatis.annotations.*;

/**
 * @author mzy
 * @description 针对表【tb_worker】的数据库操作Mapper
 * @createDate 2024-11-16 13:51:27
 * @Entity com.pojo.Worker
 */
public interface WorkerMapper {

    int deleteByPrimaryKey(Long id);

    int insert(Worker record);

    int insertSelective(Worker record);

    Worker selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(Worker record);

    int updateByPrimaryKey(Worker record);

    @Select("select * from tb_worker where id=#{id}")
    Worker selectWorker(int i);


    @Insert("insert into  tb_worker(name, age, sex, worker_id) " +
            "values (#{name},#{age},#{sex},#{workerId})")
    int insertWorker(Worker worker);

    @Update("update tb_worker set name = #{name},age = #{age} " +
            "where id = #{id}")
    int updateWorker(Worker worker);

    @Delete("delete from tb_worker where id = #{id}")
    int deleteWorker(int id);

    @Select("select * from tb_worker where id=#{param1} and name=#{param2}")
    Worker selectWorkerByIdAndName(@Param("param1") int id, @Param("param2") String name);
}

